To Create a One Table View

Create the view.

CREATE OR REPLACE VIEW MY_VIEW
AS SELECT ObjectID, Elevation, Geometry
From MY_TABLE;

Create a primary key on the view.

ALTER VIEW MY_VIEW 
ADD PRIMARY KEY (ObjectID) DISABLE;

Insert the view in the Oracle Spatial metadata.

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES (‘MY_VIEW', 'Geometry',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),
MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)),
82247);